Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 1380 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 140.3 KiB |
| Average record size in memory | 104.1 B |
Variable types
| Numeric | 12 |
|---|---|
| DateTime | 1 |
unpaid has constant value "0" | Constant |
df_index is highly correlated with relative_hour | High correlation |
gpu_memory_usage is highly correlated with gpu_load and 2 other fields | High correlation |
gpu_load is highly correlated with gpu_memory_usage and 2 other fields | High correlation |
gpu_temp is highly correlated with gpu_memory_usage and 2 other fields | High correlation |
reported_hashrate is highly correlated with gpu_memory_usage and 2 other fields | High correlation |
relative_hour is highly correlated with df_index | High correlation |
cpu_load is highly skewed (γ1 = 31.45408782) | Skewed |
df_index has unique values | Unique |
ts has unique values | Unique |
relative_hour has unique values | Unique |
gpu_load has 282 (20.4%) zeros | Zeros |
unpaid has 1380 (100.0%) zeros | Zeros |
reported_hashrate has 282 (20.4%) zeros | Zeros |
Reproduction
| Analysis started | 2021-12-01 03:31:26.272914 |
|---|---|
| Analysis finished | 2021-12-01 03:31:46.392196 |
| Duration | 20.12 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 1380 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 820.3782609 |
| Minimum | 0 |
|---|---|
| Maximum | 1553 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 68.95 |
| Q1 | 518.75 |
| median | 863.5 |
| Q3 | 1208.25 |
| 95-th percentile | 1484.05 |
| Maximum | 1553 |
| Range | 1553 |
| Interquartile range (IQR) | 689.5 |
Descriptive statistics
| Standard deviation | 457.4446574 |
|---|---|
| Coefficient of variation (CV) | 0.55760212 |
| Kurtosis | -1.137130293 |
| Mean | 820.3782609 |
| Median Absolute Deviation (MAD) | 345 |
| Skewness | -0.2299526691 |
| Sum | 1132122 |
| Variance | 209255.6146 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | 0.1% |
| 1091 | 1 | 0.1% |
| 1099 | 1 | 0.1% |
| 1098 | 1 | 0.1% |
| 1097 | 1 | 0.1% |
| 1096 | 1 | 0.1% |
| 1095 | 1 | 0.1% |
| 1094 | 1 | 0.1% |
| 1093 | 1 | 0.1% |
| 1092 | 1 | 0.1% |
| Other values (1370) | 1370 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 |
| Value | Count | Frequency (%) |
| 1553 | 1 | |
| 1552 | 1 | |
| 1551 | 1 | |
| 1550 | 1 | |
| 1549 | 1 |
| Distinct | 1380 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 KiB |
| Minimum | 2021-11-11 08:40:46-05:00 |
|---|---|
| Maximum | 2021-11-11 13:10:12-05:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2588405797 |
| Minimum | 0.1 |
|---|---|
| Maximum | 12.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 0.2 |
| median | 0.2 |
| Q3 | 0.3 |
| 95-th percentile | 0.4 |
| Maximum | 12.5 |
| Range | 12.4 |
| Interquartile range (IQR) | 0.1 |
Descriptive statistics
| Standard deviation | 0.3488114544 |
|---|---|
| Coefficient of variation (CV) | 1.347591845 |
| Kurtosis | 1101.82932 |
| Mean | 0.2588405797 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 31.45408782 |
| Sum | 357.2 |
| Variance | 0.1216694307 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 0.2 | 655 | |
| 0.3 | 442 | |
| 0.1 | 155 | 11.2% |
| 0.4 | 60 | 4.3% |
| 0.5 | 24 | 1.7% |
| 0.6 | 20 | 1.4% |
| 0.7 | 14 | 1.0% |
| 0.8 | 4 | 0.3% |
| 0.9 | 4 | 0.3% |
| 12.5 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 0.1 | 155 | 11.2% |
| 0.2 | 655 | |
| 0.3 | 442 | |
| 0.4 | 60 | 4.3% |
| 0.5 | 24 | 1.7% |
| Value | Count | Frequency (%) |
| 12.5 | 1 | 0.1% |
| 1 | 1 | 0.1% |
| 0.9 | 4 | 0.3% |
| 0.8 | 4 | 0.3% |
| 0.7 | 14 |
cpu_freq
Real number (ℝ≥0)
| Distinct | 1335 |
|---|---|
| Distinct (%) | 96.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 940.7778841 |
| Minimum | 802.77 |
|---|---|
| Maximum | 3593.97 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 802.77 |
|---|---|
| 5-th percentile | 818.825 |
| Q1 | 845.2625 |
| median | 878.865 |
| Q3 | 930.65 |
| 95-th percentile | 1170.6605 |
| Maximum | 3593.97 |
| Range | 2791.2 |
| Interquartile range (IQR) | 85.3875 |
Descriptive statistics
| Standard deviation | 280.275704 |
|---|---|
| Coefficient of variation (CV) | 0.2979191037 |
| Kurtosis | 52.56019129 |
| Mean | 940.7778841 |
| Median Absolute Deviation (MAD) | 40.43 |
| Skewness | 6.736760048 |
| Sum | 1298273.48 |
| Variance | 78554.47024 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1002.15 | 2 | 0.1% |
| 979.57 | 2 | 0.1% |
| 816.34 | 2 | 0.1% |
| 1097.94 | 2 | 0.1% |
| 817.08 | 2 | 0.1% |
| 998.39 | 2 | 0.1% |
| 1097.83 | 2 | 0.1% |
| 883.57 | 2 | 0.1% |
| 879.14 | 2 | 0.1% |
| 942.78 | 2 | 0.1% |
| Other values (1325) | 1360 |
| Value | Count | Frequency (%) |
| 802.77 | 1 | |
| 806.09 | 1 | |
| 806.14 | 1 | |
| 807.9 | 1 | |
| 808.22 | 1 |
| Value | Count | Frequency (%) |
| 3593.97 | 1 | |
| 3593.78 | 1 | |
| 3593.63 | 1 | |
| 3593.56 | 1 | |
| 3593.19 | 1 |
memory_usage
Real number (ℝ≥0)
| Distinct | 1228 |
|---|---|
| Distinct (%) | 89.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1832794821 |
| Minimum | 1358897152 |
|---|---|
| Maximum | 1992646656 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 1358897152 |
|---|---|
| 5-th percentile | 1361993318 |
| Q1 | 1892032512 |
| median | 1979025408 |
| Q3 | 1985352704 |
| 95-th percentile | 1988375142 |
| Maximum | 1992646656 |
| Range | 633749504 |
| Interquartile range (IQR) | 93320192 |
Descriptive statistics
| Standard deviation | 247732712.2 |
|---|---|
| Coefficient of variation (CV) | 0.1351666369 |
| Kurtosis | -0.5470334329 |
| Mean | 1832794821 |
| Median Absolute Deviation (MAD) | 7792640 |
| Skewness | -1.17238198 |
| Sum | 2.529256854 × 1012 |
| Variance | 6.137149669 × 1016 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1986654208 | 3 | 0.2% |
| 1893785600 | 3 | 0.2% |
| 1986883584 | 3 | 0.2% |
| 1361186816 | 3 | 0.2% |
| 1985888256 | 3 | 0.2% |
| 1976836096 | 3 | 0.2% |
| 1979363328 | 3 | 0.2% |
| 1985732608 | 2 | 0.1% |
| 1986289664 | 2 | 0.1% |
| 1985757184 | 2 | 0.1% |
| Other values (1218) | 1353 |
| Value | Count | Frequency (%) |
| 1358897152 | 1 | |
| 1359486976 | 1 | |
| 1359704064 | 1 | |
| 1359745024 | 1 | |
| 1359929344 | 1 |
| Value | Count | Frequency (%) |
| 1992646656 | 1 | |
| 1990811648 | 1 | |
| 1990627328 | 1 | |
| 1990594560 | 1 | |
| 1990434816 | 1 |
cpu_temp
Real number (ℝ≥0)
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.28985507 |
| Minimum | 25 |
|---|---|
| Maximum | 35 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 25 |
|---|---|
| 5-th percentile | 26 |
| Q1 | 31 |
| median | 32 |
| Q3 | 33 |
| 95-th percentile | 33 |
| Maximum | 35 |
| Range | 10 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.247237926 |
|---|---|
| Coefficient of variation (CV) | 0.07182001709 |
| Kurtosis | 0.3636149802 |
| Mean | 31.28985507 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.252130337 |
| Sum | 43180 |
| Variance | 5.050078297 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 32 | 467 | |
| 33 | 412 | |
| 31 | 117 | 8.5% |
| 27 | 97 | 7.0% |
| 26 | 89 | 6.4% |
| 34 | 64 | 4.6% |
| 29 | 51 | 3.7% |
| 30 | 50 | 3.6% |
| 28 | 30 | 2.2% |
| 25 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 25 | 2 | 0.1% |
| 26 | 89 | |
| 27 | 97 | |
| 28 | 30 | 2.2% |
| 29 | 51 |
| Value | Count | Frequency (%) |
| 35 | 1 | 0.1% |
| 34 | 64 | 4.6% |
| 33 | 412 | |
| 32 | 467 | |
| 31 | 117 | 8.5% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1829049353 |
| Minimum | 9437184 |
|---|---|
| Maximum | 2296381440 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 9437184 |
|---|---|
| 5-th percentile | 9437184 |
| Q1 | 2296381440 |
| median | 2296381440 |
| Q3 | 2296381440 |
| 95-th percentile | 2296381440 |
| Maximum | 2296381440 |
| Range | 2286944256 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 922485666.4 |
|---|---|
| Coefficient of variation (CV) | 0.5043525288 |
| Kurtosis | 0.1553546084 |
| Mean | 1829049353 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.468036634 |
| Sum | 2.524088107 × 1012 |
| Variance | 8.509798046 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=2)
| Value | Count | Frequency (%) |
| 2296381440 | 1098 | |
| 9437184 | 282 | 20.4% |
| Value | Count | Frequency (%) |
| 9437184 | 282 | 20.4% |
| 2296381440 | 1098 |
| Value | Count | Frequency (%) |
| 2296381440 | 1098 | |
| 9437184 | 282 | 20.4% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.56521739 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 282 |
| Zeros (%) | 20.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 100 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 40.33704206 |
|---|---|
| Coefficient of variation (CV) | 0.5069682881 |
| Kurtosis | 0.1553546084 |
| Mean | 79.56521739 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.468036634 |
| Sum | 109800 |
| Variance | 1627.076962 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=2)
| Value | Count | Frequency (%) |
| 100 | 1098 | |
| 0 | 282 | 20.4% |
| Value | Count | Frequency (%) |
| 0 | 282 | 20.4% |
| 100 | 1098 |
| Value | Count | Frequency (%) |
| 100 | 1098 | |
| 0 | 282 | 20.4% |
| Distinct | 50 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58.46956522 |
| Minimum | 29 |
|---|---|
| Maximum | 78 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 29 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 62 |
| median | 64 |
| Q3 | 66 |
| 95-th percentile | 71 |
| Maximum | 78 |
| Range | 49 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 13.92650661 |
|---|---|
| Coefficient of variation (CV) | 0.2381838579 |
| Kurtosis | 0.1678195859 |
| Mean | 58.46956522 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -1.356504881 |
| Sum | 80688 |
| Variance | 193.9475865 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 64 | 245 | |
| 63 | 196 | |
| 65 | 159 | |
| 66 | 112 | 8.1% |
| 29 | 108 | 7.8% |
| 67 | 94 | 6.8% |
| 68 | 60 | 4.3% |
| 30 | 47 | 3.4% |
| 69 | 40 | 2.9% |
| 71 | 37 | 2.7% |
| Other values (40) | 282 |
| Value | Count | Frequency (%) |
| 29 | 108 | |
| 30 | 47 | |
| 31 | 16 | 1.2% |
| 32 | 35 | 2.5% |
| 33 | 18 | 1.3% |
| Value | Count | Frequency (%) |
| 78 | 1 | 0.1% |
| 77 | 2 | 0.1% |
| 76 | 1 | 0.1% |
| 75 | 7 | |
| 74 | 10 |
hashrate
Real number (ℝ≥0)
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2502415.456 |
| Minimum | 1111111.11 |
|---|---|
| Maximum | 4444444.44 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 1111111.11 |
|---|---|
| 5-th percentile | 1111111.11 |
| Q1 | 2222222.22 |
| median | 2222222.22 |
| Q3 | 3333333.33 |
| 95-th percentile | 3333333.33 |
| Maximum | 4444444.44 |
| Range | 3333333.33 |
| Interquartile range (IQR) | 1111111.11 |
Descriptive statistics
| Standard deviation | 800766.1333 |
|---|---|
| Coefficient of variation (CV) | 0.3199972775 |
| Kurtosis | -0.03710761797 |
| Mean | 2502415.456 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.2794040705 |
| Sum | 3453333330 |
| Variance | 6.412264003 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=4)
| Value | Count | Frequency (%) |
| 2222222.22 | 756 | |
| 3333333.33 | 396 | |
| 1111111.11 | 168 | 12.2% |
| 4444444.44 | 60 | 4.3% |
| Value | Count | Frequency (%) |
| 1111111.11 | 168 | 12.2% |
| 2222222.22 | 756 | |
| 3333333.33 | 396 | |
| 4444444.44 | 60 | 4.3% |
| Value | Count | Frequency (%) |
| 4444444.44 | 60 | 4.3% |
| 3333333.33 | 396 | |
| 2222222.22 | 756 | |
| 1111111.11 | 168 | 12.2% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0 |
| Minimum | 0 |
|---|---|
| Maximum | 0 |
| Zeros | 1380 |
| Zeros (%) | 100.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 0 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0 |
|---|---|
| Coefficient of variation (CV) | nan |
| Kurtosis | 0 |
| Mean | 0 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0 |
| Sum | 0 |
| Variance | 0 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=1)
| Value | Count | Frequency (%) |
| 0 | 1380 |
| Value | Count | Frequency (%) |
| 0 | 1380 |
| Value | Count | Frequency (%) |
| 0 | 1380 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2546086.957 |
| Minimum | 0 |
|---|---|
| Maximum | 3200000 |
| Zeros | 282 |
| Zeros (%) | 20.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3200000 |
| median | 3200000 |
| Q3 | 3200000 |
| 95-th percentile | 3200000 |
| Maximum | 3200000 |
| Range | 3200000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1290785.346 |
|---|---|
| Coefficient of variation (CV) | 0.5069682881 |
| Kurtosis | 0.1553546084 |
| Mean | 2546086.957 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.468036634 |
| Sum | 3513600000 |
| Variance | 1.666126809 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=2)
| Value | Count | Frequency (%) |
| 3200000 | 1098 | |
| 0 | 282 | 20.4% |
| Value | Count | Frequency (%) |
| 0 | 282 | 20.4% |
| 3200000 | 1098 |
| Value | Count | Frequency (%) |
| 3200000 | 1098 | |
| 0 | 282 | 20.4% |
| Distinct | 1380 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.374058575 |
| Minimum | 0 |
|---|---|
| Maximum | 4.490555556 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1995833333 |
| Q1 | 1.502083333 |
| median | 2.499305556 |
| Q3 | 3.49625 |
| 95-th percentile | 4.292361111 |
| Maximum | 4.490555556 |
| Range | 4.490555556 |
| Interquartile range (IQR) | 1.994166667 |
Descriptive statistics
| Standard deviation | 1.323159755 |
|---|---|
| Coefficient of variation (CV) | 0.557340821 |
| Kurtosis | -1.137122061 |
| Mean | 2.374058575 |
| Median Absolute Deviation (MAD) | 0.9977777778 |
| Skewness | -0.2315092025 |
| Sum | 3276.200833 |
| Variance | 1.750751738 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | 0.1% |
| 3.1575 | 1 | 0.1% |
| 3.180833333 | 1 | 0.1% |
| 3.177777778 | 1 | 0.1% |
| 3.175 | 1 | 0.1% |
| 3.171944444 | 1 | 0.1% |
| 3.169166667 | 1 | 0.1% |
| 3.166111111 | 1 | 0.1% |
| 3.163333333 | 1 | 0.1% |
| 3.160555556 | 1 | 0.1% |
| Other values (1370) | 1370 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.003055555556 | 1 | |
| 0.005833333333 | 1 | |
| 0.008888888889 | 1 | |
| 0.01166666667 | 1 |
| Value | Count | Frequency (%) |
| 4.490555556 | 1 | |
| 4.4875 | 1 | |
| 4.484722222 | 1 | |
| 4.481944444 | 1 | |
| 4.478888889 | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | ts | cpu_load | cpu_freq | memory_usage | cpu_temp | gpu_memory_usage | gpu_load | gpu_temp | hashrate | unpaid | reported_hashrate | relative_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 2021-11-11 08:40:46-05:00 | 12.5 | 875.35 | 1361072128 | 28.0 | 9437184.0 | 0.0 | 33.0 | 2222222.22 | 0 | 0.0 | 0.000000 |
| 1 | 1 | 2021-11-11 08:40:57-05:00 | 0.2 | 1126.39 | 1362071552 | 27.0 | 9437184.0 | 0.0 | 33.0 | 2222222.22 | 0 | 0.0 | 0.003056 |
| 2 | 2 | 2021-11-11 08:41:07-05:00 | 0.2 | 813.76 | 1362223104 | 27.0 | 9437184.0 | 0.0 | 33.0 | 2222222.22 | 0 | 0.0 | 0.005833 |
| 3 | 3 | 2021-11-11 08:41:18-05:00 | 0.1 | 844.80 | 1362845696 | 28.0 | 9437184.0 | 0.0 | 33.0 | 2222222.22 | 0 | 0.0 | 0.008889 |
| 4 | 4 | 2021-11-11 08:41:28-05:00 | 0.2 | 892.35 | 1361985536 | 27.0 | 9437184.0 | 0.0 | 33.0 | 2222222.22 | 0 | 0.0 | 0.011667 |
| 5 | 5 | 2021-11-11 08:41:38-05:00 | 0.1 | 816.02 | 1361108992 | 28.0 | 9437184.0 | 0.0 | 32.0 | 2222222.22 | 0 | 0.0 | 0.014444 |
| 6 | 6 | 2021-11-11 08:41:49-05:00 | 0.3 | 996.34 | 1360977920 | 28.0 | 9437184.0 | 0.0 | 32.0 | 2222222.22 | 0 | 0.0 | 0.017500 |
| 7 | 7 | 2021-11-11 08:41:59-05:00 | 0.1 | 834.96 | 1360003072 | 28.0 | 9437184.0 | 0.0 | 32.0 | 2222222.22 | 0 | 0.0 | 0.020278 |
| 8 | 8 | 2021-11-11 08:42:10-05:00 | 0.2 | 3593.97 | 1360556032 | 27.0 | 9437184.0 | 0.0 | 32.0 | 2222222.22 | 0 | 0.0 | 0.023333 |
| 9 | 9 | 2021-11-11 08:42:20-05:00 | 0.1 | 849.03 | 1360936960 | 27.0 | 9437184.0 | 0.0 | 32.0 | 2222222.22 | 0 | 0.0 | 0.026111 |
Last rows
| df_index | ts | cpu_load | cpu_freq | memory_usage | cpu_temp | gpu_memory_usage | gpu_load | gpu_temp | hashrate | unpaid | reported_hashrate | relative_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1370 | 1544 | 2021-11-11 13:08:39-05:00 | 0.1 | 820.21 | 1894973440 | 28.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.464722 |
| 1371 | 1545 | 2021-11-11 13:08:49-05:00 | 0.1 | 1045.11 | 1894100992 | 30.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.467500 |
| 1372 | 1546 | 2021-11-11 13:08:59-05:00 | 0.1 | 958.21 | 1893572608 | 29.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.470278 |
| 1373 | 1547 | 2021-11-11 13:09:10-05:00 | 0.2 | 835.80 | 1894072320 | 28.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.473333 |
| 1374 | 1548 | 2021-11-11 13:09:20-05:00 | 0.1 | 878.80 | 1894047744 | 29.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.476111 |
| 1375 | 1549 | 2021-11-11 13:09:30-05:00 | 0.1 | 1170.61 | 1894055936 | 28.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.478889 |
| 1376 | 1550 | 2021-11-11 13:09:41-05:00 | 0.1 | 874.17 | 1893789696 | 29.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.481944 |
| 1377 | 1551 | 2021-11-11 13:09:51-05:00 | 0.1 | 831.05 | 1894072320 | 29.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.484722 |
| 1378 | 1552 | 2021-11-11 13:10:01-05:00 | 0.1 | 885.64 | 1893789696 | 29.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.487500 |
| 1379 | 1553 | 2021-11-11 13:10:12-05:00 | 0.1 | 835.07 | 1894305792 | 29.0 | 9437184.0 | 0.0 | 32.0 | 1111111.11 | 0 | 0.0 | 4.490556 |